# define sql statement.

CREATE TABLE IF NOT EXISTS role (
	`uid`          bigint(20) unsigned NOT NULL,
    `name`         varchar(1024),
    `level`        int(10) default 1,
    `account`      varchar(1024) NOT NULL,
    `ts`           TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY(`uid`)
) DEFAULT CHARSET = UTF8;